﻿///***************************************************************
/// 시  스  템 : Updms.Crd.Dac
/// 단위시스템 : CRD
/// 계      층 : Data Access Layer
/// 프로그램명 : Crd_Dac_UPDMS_CRD_REPORT_Crd3010p
/// 파  일  명 : Crd_Dac_UPDMS_CRD_REPORT_Crd3010p.cs
/// 설      명 : 카드 대쉬보드
///***************************************************************
/// 수정ID 일자       이름     내용
///---------------------------------------------------------------
/// CH001  2008-08-11 송시명   최초 작성
///***************************************************************
using System.Data;
using System.Data.SqlClient;
using System.EnterpriseServices;
using System.Runtime.InteropServices;

using SMFramework.Data;


namespace Updms.Crd.Dac
{
	[ComVisible(true)]
	[Transaction(TransactionOption.Supported)]
	[JustInTimeActivation(true)]
	public class Crd_Dac_UPDMS_CRD_REPORT_Crd3010p : Base.AppFramework.DacBase
	{
		public Crd_Dac_UPDMS_CRD_REPORT_Crd3010p()
		{
		}

		#region NT [GetImportantItemList]
		/// <summary>
		/// 주요 아이템별 카드사용리스트
		/// </summary>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetImportantItemList()
		{
			string strSql = "usp_UPDMS_CRD_REPORT_Crd3010p_Get_Important_Item_List";

			DataSet ds = new DataSet();
			return _agent.Fill(strSql, "UPDMS_CRD_REPORT", ds, null, CommandType.StoredProcedure);
		}
		
		#endregion

		#region NT [GetAccountList]

		/// <summary>
		/// 항목별 리스트
		/// </summary>
		/// <param name="lo_dp"></param>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetAccountList(DataPack lo_dp)
		{
			string strSql = "usp_UPDMS_CRD_REPORT_Crd3010p_Get_Account_List";

			SqlParameter[] paramArray = lo_dp.ToSqlParameters();

			DataSet ds = new DataSet();
			return _agent.Fill(strSql, "UPDMS_CRD_REPORT", ds, paramArray, CommandType.StoredProcedure);
		}
		
		#endregion

		#region NT [GetAccountDetailList]

		/// <summary>
		/// 항목별 상세리스트
		/// </summary>
		/// <param name="lo_dp"></param>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetAccountDetailList(DataPack lo_dp)
		{
			string strSql = "usp_UPDMS_CRD_REPORT_Crd3010p_Get_Account_Detail_List";

			SqlParameter[] paramArray = lo_dp.ToSqlParameters();

			DataSet ds = new DataSet();
			return _agent.Fill(strSql, "UPDMS_CRD_REPORT", ds, paramArray, CommandType.StoredProcedure);
		}

		#endregion

		#region NT [GetMonthlyTotalAmtListOnDashboard]

		/// <summary>
		/// 결제총액리스트 (대시보드용)
		/// </summary>
		/// <param name="lo_dp"></param>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetMonthlyTotalAmtListOnDashboard(DataPack lo_dp)
		{
			string strSql = "usp_UPDMS_CRD_REPORT_Crd3010p_Get_Monthly_Total_Amt_List_On_Dashboard";

			SqlParameter[] paramArray = lo_dp.ToSqlParameters();

			DataSet ds = new DataSet();
			return _agent.Fill(strSql, "UPDMS_CRD_REPORT", ds, paramArray, CommandType.StoredProcedure);
		}

		#endregion

	}
}
